Dataset info
| Number of variables | 38 |
|---|---|
| Number of observations | 300000 |
| Missing cells | 0 (0.0%) |
| Duplicate rows | 0 (0.0%) |
| Total size in memory | 87.0 MiB |
| Average record size in memory | 304.0 B |
Variables types
| Numeric | 23 |
|---|---|
| Categorical | 7 |
| Boolean | 5 |
| Date | 0 |
| URL | 0 |
| Text (Unique) | 0 |
| Rejected | 3 |
| Unsupported | 0 |
Warnings
var10 has 210371 (70.1%) zeros | Zeros |
var11 has 253621 (84.5%) zeros | Zeros |
var12 has 24118 (8.0%) zeros | Zeros |
var14 has 212476 (70.8%) zeros | Zeros |
var2 has 288810 (96.3%) zeros | Zeros |
var21 has 25538 (8.5%) zeros | Zeros |
var22 is highly correlated with var13 (ρ = 0.9039894224) | Rejected |
var23 is highly correlated with var13 (ρ = 0.9025962546) | Rejected |
var24 has 146090 (48.7%) zeros | Zeros |
var28 has 173435 (57.8%) zeros | Zeros |
var29 has 173582 (57.9%) zeros | Zeros |
var3 has 193891 (64.6%) zeros | Zeros |
var30 has constant value "." | Rejected |
var31 has 280292 (93.4%) zeros | Zeros |
var5 has 258691 (86.2%) zeros | Zeros |
var6 has 30269 (10.1%) zeros | Zeros |
var7 has 231090 (77.0%) zeros | Zeros |
var8 has 112949 (37.6%) zeros | Zeros |
cust_id
Numeric
| Distinct count | 300000 |
|---|---|
| Unique (%) | 100.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 250000.5 |
|---|---|
| Minimum | 100001 |
| Maximum | 400000 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 100001 |
|---|---|
| 5-th percentile | 115000.95 |
| Q1 | 175000.75 |
| Median | 250000.5 |
| Q3 | 325000.25 |
| 95-th percentile | 385000.05 |
| Maximum | 400000 |
| Range | 299999 |
| Interquartile range | 149999.5 |
Descriptive statistics
| Standard deviation | 86602.68472 |
|---|---|
| Coef of variation | 0.346410046 |
| Kurtosis | -1.2 |
| Mean | 250000.5 |
| MAD | 75000 |
| Skewness | 0 |
| Sum | 7.500015e+10 |
| Variance | 7500025000 |
| Memory size | 2.3 MiB |
| Value | Count | Frequency (%) | |
| 396537 | 1 | < 0.1% | |
| 335491 | 1 | < 0.1% | |
| 352774 | 1 | < 0.1% | |
| 335479 | 1 | < 0.1% | |
| 167740 | 1 | < 0.1% | |
| 354682 | 1 | < 0.1% | |
| 335481 | 1 | < 0.1% | |
| 167741 | 1 | < 0.1% | |
| 335483 | 1 | < 0.1% | |
| 167742 | 1 | < 0.1% | |
| Other values (299990) | 299990 | > 99.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 100001 | 1 | < 0.1% | |
| 100002 | 1 | < 0.1% | |
| 100003 | 1 | < 0.1% | |
| 100004 | 1 | < 0.1% | |
| 100005 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 400000 | 1 | < 0.1% | |
| 399999 | 1 | < 0.1% | |
| 399998 | 1 | < 0.1% | |
| 399997 | 1 | < 0.1% | |
| 399996 | 1 | < 0.1% |
self_service_platform
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Desktop | |
|---|---|
| Mobile App | |
| Mobile Web |
| Value | Count | Frequency (%) | |
| Desktop | 184194 | 61.4% | |
| Mobile App | 55595 | 18.5% | |
| Mobile Web | 48063 | 16.0% | |
| STB | 12148 | 4.0% |
| Max length | 10 |
|---|---|
| Mean length | 7.874606667 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
var1
Numeric
| Distinct count | 15684 |
|---|---|
| Unique (%) | 5.2% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 2987.161307 |
|---|---|
| Minimum | 20 |
| Maximum | 17337 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 20 |
|---|---|
| 5-th percentile | 133 |
| Q1 | 544 |
| Median | 1862 |
| Q3 | 3616 |
| 95-th percentile | 10630.05 |
| Maximum | 17337 |
| Range | 17317 |
| Interquartile range | 3072 |
Descriptive statistics
| Standard deviation | 3349.886526 |
|---|---|
| Coef of variation | 1.121428066 |
| Kurtosis | 2.459042654 |
| Mean | 2987.161307 |
| MAD | 2483.13401 |
| Skewness | 1.701164708 |
| Sum | 896148392 |
| Variance | 11221739.74 |
| Memory size | 2.3 MiB |
| Value | Count | Frequency (%) | |
| 142 | 274 | 0.1% | |
| 147 | 245 | 0.1% | |
| 293 | 234 | 0.1% | |
| 51 | 228 | 0.1% | |
| 136 | 219 | 0.1% | |
| 117 | 206 | 0.1% | |
| 310 | 201 | 0.1% | |
| 135 | 198 | 0.1% | |
| 112 | 198 | 0.1% | |
| 118 | 195 | 0.1% | |
| Other values (15674) | 297802 | 99.3% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 20 | 85 | < 0.1% | |
| 21 | 82 | < 0.1% | |
| 22 | 96 | < 0.1% | |
| 23 | 92 | < 0.1% | |
| 24 | 102 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 17337 | 1 | < 0.1% | |
| 17336 | 1 | < 0.1% | |
| 17330 | 1 | < 0.1% | |
| 17329 | 1 | < 0.1% | |
| 17327 | 1 | < 0.1% |
var10
Numeric
| Distinct count | 200 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 3.18996 |
|---|---|
| Minimum | 0 |
| Maximum | 343 |
| Zeros (%) | 70.1% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 1 |
| 95-th percentile | 10 |
| Maximum | 343 |
| Range | 343 |
| Interquartile range | 1 |
Descriptive statistics
| Standard deviation | 14.64196651 |
|---|---|
| Coef of variation | 4.590015707 |
| Kurtosis | 65.76098123 |
| Mean | 3.18996 |
| MAD | 5.154559063 |
| Skewness | 7.385918786 |
| Sum | 956988 |
| Variance | 214.3871832 |
| Memory size | 2.3 MiB |
| Value | Count | Frequency (%) | |
| 0 | 210371 | 70.1% | |
| 1 | 37449 | 12.5% | |
| 2 | 15881 | 5.3% | |
| 3 | 6313 | 2.1% | |
| 5 | 2488 | 0.8% | |
| 4 | 2390 | 0.8% | |
| 8 | 2248 | 0.7% | |
| 10 | 2187 | 0.7% | |
| 7 | 2108 | 0.7% | |
| 11 | 2095 | 0.7% | |
| Other values (190) | 16470 | 5.5% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 210371 | 70.1% | |
| 1 | 37449 | 12.5% | |
| 2 | 15881 | 5.3% | |
| 3 | 6313 | 2.1% | |
| 4 | 2390 | 0.8% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 343 | 1 | < 0.1% | |
| 342 | 1 | < 0.1% | |
| 341 | 1 | < 0.1% | |
| 334 | 1 | < 0.1% | |
| 332 | 1 | < 0.1% |
var11
Numeric
| Distinct count | 12 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.3548266667 |
|---|---|
| Minimum | 0 |
| Maximum | 11 |
| Zeros (%) | 84.5% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 2 |
| Maximum | 11 |
| Range | 11 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 1.131227491 |
|---|---|
| Coef of variation | 3.188112949 |
| Kurtosis | 26.00270102 |
| Mean | 0.3548266667 |
| MAD | 0.5999432935 |
| Skewness | 4.662376591 |
| Sum | 106448 |
| Variance | 1.279675636 |
| Memory size | 2.3 MiB |
| Value | Count | Frequency (%) | |
| 0 | 253621 | 84.5% | |
| 1 | 24328 | 8.1% | |
| 3 | 7483 | 2.5% | |
| 2 | 7232 | 2.4% | |
| 7 | 1497 | 0.5% | |
| 5 | 1485 | 0.5% | |
| 6 | 1481 | 0.5% | |
| 4 | 1465 | 0.5% | |
| 8 | 764 | 0.3% | |
| 11 | 222 | 0.1% | |
| Other values (2) | 422 | 0.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 253621 | 84.5% | |
| 1 | 24328 | 8.1% | |
| 2 | 7232 | 2.4% | |
| 3 | 7483 | 2.5% | |
| 4 | 1465 | 0.5% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 11 | 222 | 0.1% | |
| 10 | 205 | 0.1% | |
| 9 | 217 | 0.1% | |
| 8 | 764 | 0.3% | |
| 7 | 1497 | 0.5% |
var12
Numeric
| Distinct count | 8036 |
|---|---|
| Unique (%) | 2.7% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 567.0044167 |
|---|---|
| Minimum | 0 |
| Maximum | 10198 |
| Zeros (%) | 8.0% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 27 |
| Median | 183 |
| Q3 | 589 |
| 95-th percentile | 2425 |
| Maximum | 10198 |
| Range | 10198 |
| Interquartile range | 562 |
Descriptive statistics
| Standard deviation | 1185.068602 |
|---|---|
| Coef of variation | 2.090051801 |
| Kurtosis | 24.1055967 |
| Mean | 567.0044167 |
| MAD | 637.0360422 |
| Skewness | 4.525367495 |
| Sum | 170101325 |
| Variance | 1404387.592 |
| Memory size | 2.3 MiB |
| Value | Count | Frequency (%) | |
| 0 | 24118 | 8.0% | |
| 1 | 6494 | 2.2% | |
| 2 | 1967 | 0.7% | |
| 7 | 1903 | 0.6% | |
| 11 | 1902 | 0.6% | |
| 14 | 1865 | 0.6% | |
| 9 | 1859 | 0.6% | |
| 17 | 1850 | 0.6% | |
| 18 | 1849 | 0.6% | |
| 15 | 1848 | 0.6% | |
| Other values (8026) | 254345 | 84.8% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 24118 | 8.0% | |
| 1 | 6494 | 2.2% | |
| 2 | 1967 | 0.7% | |
| 3 | 1841 | 0.6% | |
| 4 | 1834 | 0.6% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 10198 | 1 | < 0.1% | |
| 10192 | 2 | < 0.1% | |
| 10187 | 1 | < 0.1% | |
| 10184 | 2 | < 0.1% | |
| 10183 | 1 | < 0.1% |
var13
Numeric
| Distinct count | 1894 |
|---|---|
| Unique (%) | 0.6% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 509.44858 |
|---|---|
| Minimum | 0 |
| Maximum | 1893 |
| Zeros (%) | < 0.1% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 68 |
| Q1 | 174 |
| Median | 437 |
| Q3 | 708 |
| 95-th percentile | 1273 |
| Maximum | 1893 |
| Range | 1893 |
| Interquartile range | 534 |
Descriptive statistics
| Standard deviation | 378.7793299 |
|---|---|
| Coef of variation | 0.7435084614 |
| Kurtosis | 0.4150410677 |
| Mean | 509.44858 |
| MAD | 300.9163942 |
| Skewness | 0.9230621604 |
| Sum | 152834574 |
| Variance | 143473.7807 |
| Memory size | 2.3 MiB |
| Value | Count | Frequency (%) | |
| 83 | 1288 | 0.4% | |
| 71 | 1267 | 0.4% | |
| 79 | 1206 | 0.4% | |
| 75 | 1161 | 0.4% | |
| 78 | 1152 | 0.4% | |
| 77 | 1131 | 0.4% | |
| 73 | 1118 | 0.4% | |
| 72 | 1110 | 0.4% | |
| 76 | 1106 | 0.4% | |
| 81 | 1100 | 0.4% | |
| Other values (1884) | 288361 | 96.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 138 | < 0.1% | |
| 1 | 164 | 0.1% | |
| 2 | 169 | 0.1% | |
| 3 | 162 | 0.1% | |
| 4 | 133 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 1893 | 4 | < 0.1% | |
| 1892 | 2 | < 0.1% | |
| 1891 | 4 | < 0.1% | |
| 1890 | 3 | < 0.1% | |
| 1889 | 4 | < 0.1% |
var14
Numeric
| Distinct count | 13 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.4319466667 |
|---|---|
| Minimum | 0 |
| Maximum | 12 |
| Zeros (%) | 70.8% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 1 |
| 95-th percentile | 2 |
| Maximum | 12 |
| Range | 12 |
| Interquartile range | 1 |
Descriptive statistics
| Standard deviation | 0.9768991375 |
|---|---|
| Coef of variation | 2.261619808 |
| Kurtosis | 37.63966083 |
| Mean | 0.4319466667 |
| MAD | 0.611855333 |
| Skewness | 4.972812833 |
| Sum | 129584 |
| Variance | 0.9543319249 |
| Memory size | 2.3 MiB |
| Value | Count | Frequency (%) | |
| 0 | 212476 | 70.8% | |
| 1 | 68700 | 22.9% | |
| 2 | 11069 | 3.7% | |
| 4 | 2003 | 0.7% | |
| 3 | 1902 | 0.6% | |
| 5 | 1893 | 0.6% | |
| 6 | 853 | 0.3% | |
| 12 | 197 | 0.1% | |
| 8 | 195 | 0.1% | |
| 7 | 188 | 0.1% | |
| Other values (3) | 524 | 0.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 212476 | 70.8% | |
| 1 | 68700 | 22.9% | |
| 2 | 11069 | 3.7% | |
| 3 | 1902 | 0.6% | |
| 4 | 2003 | 0.7% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 12 | 197 | 0.1% | |
| 11 | 151 | 0.1% | |
| 10 | 187 | 0.1% | |
| 9 | 186 | 0.1% | |
| 8 | 195 | 0.1% |
var15
Numeric
| Distinct count | 3658 |
|---|---|
| Unique (%) | 1.2% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 241.37992 |
|---|---|
| Minimum | 1 |
| Maximum | 3806 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 12 |
| Q1 | 63 |
| Median | 141 |
| Q3 | 225 |
| 95-th percentile | 812 |
| Maximum | 3806 |
| Range | 3805 |
| Interquartile range | 162 |
Descriptive statistics
| Standard deviation | 419.362044 |
|---|---|
| Coef of variation | 1.737352651 |
| Kurtosis | 28.59624494 |
| Mean | 241.37992 |
| MAD | 203.8769603 |
| Skewness | 4.966453331 |
| Sum | 72413976 |
| Variance | 175864.5239 |
| Memory size | 2.3 MiB |
| Value | Count | Frequency (%) | |
| 27 | 1910 | 0.6% | |
| 165 | 1873 | 0.6% | |
| 3 | 1843 | 0.6% | |
| 106 | 1810 | 0.6% | |
| 13 | 1695 | 0.6% | |
| 102 | 1620 | 0.5% | |
| 107 | 1596 | 0.5% | |
| 105 | 1567 | 0.5% | |
| 146 | 1554 | 0.5% | |
| 2 | 1542 | 0.5% | |
| Other values (3648) | 282990 | 94.3% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 1111 | 0.4% | |
| 2 | 1542 | 0.5% | |
| 3 | 1843 | 0.6% | |
| 4 | 1104 | 0.4% | |
| 5 | 1161 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 3806 | 1 | < 0.1% | |
| 3805 | 2 | < 0.1% | |
| 3804 | 2 | < 0.1% | |
| 3803 | 1 | < 0.1% | |
| 3801 | 1 | < 0.1% |
var16
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 16121 |
| Value | Count | Frequency (%) | |
| 0 | 283879 | 94.6% | |
| 1 | 16121 | 5.4% |
var2
Numeric
| Distinct count | 32 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.56782 |
|---|---|
| Minimum | 0 |
| Maximum | 31 |
| Zeros (%) | 96.3% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 31 |
| Range | 31 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 3.352299396 |
|---|---|
| Coef of variation | 5.903806481 |
| Kurtosis | 44.21742383 |
| Mean | 0.56782 |
| MAD | 1.093280628 |
| Skewness | 6.547950247 |
| Sum | 170346 |
| Variance | 11.23791124 |
| Memory size | 2.3 MiB |
| Value | Count | Frequency (%) | |
| 0 | 288810 | 96.3% | |
| 2 | 478 | 0.2% | |
| 1 | 461 | 0.2% | |
| 4 | 397 | 0.1% | |
| 10 | 386 | 0.1% | |
| 7 | 383 | 0.1% | |
| 16 | 381 | 0.1% | |
| 18 | 377 | 0.1% | |
| 12 | 377 | 0.1% | |
| 5 | 376 | 0.1% | |
| Other values (22) | 7574 | 2.5% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 288810 | 96.3% | |
| 1 | 461 | 0.2% | |
| 2 | 478 | 0.2% | |
| 3 | 346 | 0.1% | |
| 4 | 397 | 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 31 | 222 | 0.1% | |
| 30 | 236 | 0.1% | |
| 29 | 335 | 0.1% | |
| 28 | 345 | 0.1% | |
| 27 | 327 | 0.1% |
var21
Numeric
| Distinct count | 101 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 21.04783667 |
|---|---|
| Minimum | 0 |
| Maximum | 100 |
| Zeros (%) | 8.5% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 8 |
| Median | 15 |
| Q3 | 34 |
| 95-th percentile | 60 |
| Maximum | 100 |
| Range | 100 |
| Interquartile range | 26 |
Descriptive statistics
| Standard deviation | 19.66576867 |
|---|---|
| Coef of variation | 0.9343368149 |
| Kurtosis | 1.820637864 |
| Mean | 21.04783667 |
| MAD | 15.31755222 |
| Skewness | 1.372716951 |
| Sum | 6314351 |
| Variance | 386.7424575 |
| Memory size | 2.3 MiB |
| Value | Count | Frequency (%) | |
| 0 | 25538 | 8.5% | |
| 15 | 13281 | 4.4% | |
| 8 | 10931 | 3.6% | |
| 4 | 10901 | 3.6% | |
| 9 | 10107 | 3.4% | |
| 10 | 10026 | 3.3% | |
| 11 | 9843 | 3.3% | |
| 12 | 9738 | 3.2% | |
| 14 | 9714 | 3.2% | |
| 13 | 9654 | 3.2% | |
| Other values (91) | 180267 | 60.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 25538 | 8.5% | |
| 1 | 9256 | 3.1% | |
| 2 | 9081 | 3.0% | |
| 3 | 9568 | 3.2% | |
| 4 | 10901 | 3.6% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 100 | 293 | 0.1% | |
| 99 | 293 | 0.1% | |
| 98 | 276 | 0.1% | |
| 97 | 262 | 0.1% | |
| 96 | 262 | 0.1% |
var22
Highly correlated
This variable is highly correlated with var13 and should be ignored for analysis
| Correlation | 0.9039894224 |
|---|
var23
Highly correlated
This variable is highly correlated with var13 and should be ignored for analysis
| Correlation | 0.9025962546 |
|---|
var24
Numeric
| Distinct count | 149 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 14.91602333 |
|---|---|
| Minimum | 0 |
| Maximum | 148 |
| Zeros (%) | 48.7% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 1 |
| Q3 | 19 |
| 95-th percentile | 79 |
| Maximum | 148 |
| Range | 148 |
| Interquartile range | 19 |
Descriptive statistics
| Standard deviation | 31.07231044 |
|---|---|
| Coef of variation | 2.083149761 |
| Kurtosis | 9.792276733 |
| Mean | 14.91602333 |
| MAD | 19.03585963 |
| Skewness | 3.113477409 |
| Sum | 4474807 |
| Variance | 965.4884762 |
| Memory size | 2.3 MiB |
| Value | Count | Frequency (%) | |
| 0 | 146090 | 48.7% | |
| 1 | 33185 | 11.1% | |
| 20 | 11866 | 4.0% | |
| 21 | 11215 | 3.7% | |
| 148 | 9933 | 3.3% | |
| 14 | 5262 | 1.8% | |
| 16 | 4191 | 1.4% | |
| 15 | 4040 | 1.3% | |
| 2 | 3773 | 1.3% | |
| 4 | 2381 | 0.8% | |
| Other values (139) | 68064 | 22.7% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 146090 | 48.7% | |
| 1 | 33185 | 11.1% | |
| 2 | 3773 | 1.3% | |
| 3 | 2281 | 0.8% | |
| 4 | 2381 | 0.8% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 148 | 9933 | 3.3% | |
| 147 | 20 | < 0.1% | |
| 146 | 16 | < 0.1% | |
| 145 | 18 | < 0.1% | |
| 144 | 24 | < 0.1% |
var25
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 16165 |
| Value | Count | Frequency (%) | |
| 0 | 283835 | 94.6% | |
| 1 | 16165 | 5.4% |
var26
Numeric
| Distinct count | 841 |
|---|---|
| Unique (%) | 0.3% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 18.25891333 |
|---|---|
| Minimum | 0 |
| Maximum | 845 |
| Zeros (%) | 0.5% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| Median | 5 |
| Q3 | 10 |
| 95-th percentile | 29 |
| Maximum | 845 |
| Range | 845 |
| Interquartile range | 8 |
Descriptive statistics
| Standard deviation | 73.2705098 |
|---|---|
| Coef of variation | 4.012862565 |
| Kurtosis | 60.4085094 |
| Mean | 18.25891333 |
| MAD | 23.01293016 |
| Skewness | 7.484277853 |
| Sum | 5477674 |
| Variance | 5368.567606 |
| Memory size | 2.3 MiB |
| Value | Count | Frequency (%) | |
| 1 | 49614 | 16.5% | |
| 3 | 37078 | 12.4% | |
| 6 | 29498 | 9.8% | |
| 2 | 25272 | 8.4% | |
| 5 | 25210 | 8.4% | |
| 4 | 23768 | 7.9% | |
| 7 | 17437 | 5.8% | |
| 13 | 13993 | 4.7% | |
| 14 | 12069 | 4.0% | |
| 8 | 9327 | 3.1% | |
| Other values (831) | 56734 | 18.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 1463 | 0.5% | |
| 1 | 49614 | 16.5% | |
| 2 | 25272 | 8.4% | |
| 3 | 37078 | 12.4% | |
| 4 | 23768 | 7.9% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 845 | 4 | < 0.1% | |
| 844 | 2 | < 0.1% | |
| 843 | 2 | < 0.1% | |
| 842 | 1 | < 0.1% | |
| 841 | 3 | < 0.1% |
var27
Numeric
| Distinct count | 2291 |
|---|---|
| Unique (%) | 0.8% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 210.0773233 |
|---|---|
| Minimum | 0 |
| Maximum | 21814 |
| Zeros (%) | 0.1% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 43 |
| Q1 | 79 |
| Median | 136 |
| Q3 | 181 |
| 95-th percentile | 256 |
| Maximum | 21814 |
| Range | 21814 |
| Interquartile range | 102 |
Descriptive statistics
| Standard deviation | 1024.015097 |
|---|---|
| Coef of variation | 4.874467554 |
| Kurtosis | 264.1941356 |
| Mean | 210.0773233 |
| MAD | 154.3835418 |
| Skewness | 15.76408102 |
| Sum | 63023197 |
| Variance | 1048606.918 |
| Memory size | 2.3 MiB |
| Value | Count | Frequency (%) | |
| 213 | 4321 | 1.4% | |
| 214 | 4198 | 1.4% | |
| 216 | 4092 | 1.4% | |
| 217 | 4025 | 1.3% | |
| 215 | 4003 | 1.3% | |
| 153 | 3022 | 1.0% | |
| 170 | 2443 | 0.8% | |
| 113 | 2369 | 0.8% | |
| 110 | 2242 | 0.7% | |
| 139 | 2205 | 0.7% | |
| Other values (2281) | 267080 | 89.0% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 178 | 0.1% | |
| 1 | 160 | 0.1% | |
| 2 | 170 | 0.1% | |
| 3 | 165 | 0.1% | |
| 4 | 165 | 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 21814 | 1 | < 0.1% | |
| 21803 | 1 | < 0.1% | |
| 21797 | 1 | < 0.1% | |
| 21780 | 1 | < 0.1% | |
| 21774 | 1 | < 0.1% |
var28
Numeric
| Distinct count | 1488 |
|---|---|
| Unique (%) | 0.5% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 16.59846 |
|---|---|
| Minimum | 0 |
| Maximum | 2338 |
| Zeros (%) | 57.8% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 7 |
| 95-th percentile | 27 |
| Maximum | 2338 |
| Range | 2338 |
| Interquartile range | 7 |
Descriptive statistics
| Standard deviation | 114.5120976 |
|---|---|
| Coef of variation | 6.898959156 |
| Kurtosis | 221.3998696 |
| Mean | 16.59846 |
| MAD | 25.73649106 |
| Skewness | 13.96648105 |
| Sum | 4979538 |
| Variance | 13113.0205 |
| Memory size | 2.3 MiB |
| Value | Count | Frequency (%) | |
| 0 | 173435 | 57.8% | |
| 11 | 16157 | 5.4% | |
| 10 | 14656 | 4.9% | |
| 2 | 12565 | 4.2% | |
| 1 | 10612 | 3.5% | |
| 3 | 7769 | 2.6% | |
| 6 | 7054 | 2.4% | |
| 8 | 5167 | 1.7% | |
| 7 | 5013 | 1.7% | |
| 9 | 4636 | 1.5% | |
| Other values (1478) | 42936 | 14.3% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 173435 | 57.8% | |
| 1 | 10612 | 3.5% | |
| 2 | 12565 | 4.2% | |
| 3 | 7769 | 2.6% | |
| 4 | 4622 | 1.5% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 2338 | 1 | < 0.1% | |
| 2334 | 2 | < 0.1% | |
| 2332 | 1 | < 0.1% | |
| 2331 | 2 | < 0.1% | |
| 2329 | 1 | < 0.1% |
var29
Numeric
| Distinct count | 1394 |
|---|---|
| Unique (%) | 0.5% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 15.21117667 |
|---|---|
| Minimum | 0 |
| Maximum | 2023 |
| Zeros (%) | 57.9% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 7 |
| 95-th percentile | 26 |
| Maximum | 2023 |
| Range | 2023 |
| Interquartile range | 7 |
Descriptive statistics
| Standard deviation | 100.5150909 |
|---|---|
| Coef of variation | 6.607976039 |
| Kurtosis | 214.2597354 |
| Mean | 15.21117667 |
| MAD | 23.28688922 |
| Skewness | 13.68665308 |
| Sum | 4563353 |
| Variance | 10103.28351 |
| Memory size | 2.3 MiB |
| Value | Count | Frequency (%) | |
| 0 | 173582 | 57.9% | |
| 11 | 15397 | 5.1% | |
| 10 | 14460 | 4.8% | |
| 2 | 13097 | 4.4% | |
| 1 | 10528 | 3.5% | |
| 3 | 8506 | 2.8% | |
| 5 | 6738 | 2.2% | |
| 4 | 5096 | 1.7% | |
| 9 | 4862 | 1.6% | |
| 6 | 4647 | 1.5% | |
| Other values (1384) | 43087 | 14.4% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 173582 | 57.9% | |
| 1 | 10528 | 3.5% | |
| 2 | 13097 | 4.4% | |
| 3 | 8506 | 2.8% | |
| 4 | 5096 | 1.7% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 2023 | 2 | < 0.1% | |
| 2021 | 1 | < 0.1% | |
| 2020 | 4 | < 0.1% | |
| 2019 | 3 | < 0.1% | |
| 2018 | 3 | < 0.1% |
var3
Numeric
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.4045133333 |
|---|---|
| Minimum | 0 |
| Maximum | 4 |
| Zeros (%) | 64.6% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 1 |
| 95-th percentile | 1 |
| Maximum | 4 |
| Range | 4 |
| Interquartile range | 1 |
Descriptive statistics
| Standard deviation | 0.6326481096 |
|---|---|
| Coef of variation | 1.56397344 |
| Kurtosis | 7.158780588 |
| Mean | 0.4045133333 |
| MAD | 0.5228766314 |
| Skewness | 2.132816872 |
| Sum | 121354 |
| Variance | 0.4002436306 |
| Memory size | 2.3 MiB |
| Value | Count | Frequency (%) | |
| 0 | 193891 | 64.6% | |
| 1 | 97714 | 32.6% | |
| 2 | 3354 | 1.1% | |
| 3 | 3232 | 1.1% | |
| 4 | 1809 | 0.6% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 193891 | 64.6% | |
| 1 | 97714 | 32.6% | |
| 2 | 3354 | 1.1% | |
| 3 | 3232 | 1.1% | |
| 4 | 1809 | 0.6% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 4 | 1809 | 0.6% | |
| 3 | 3232 | 1.1% | |
| 2 | 3354 | 1.1% | |
| 1 | 97714 | 32.6% | |
| 0 | 193891 | 64.6% |
var30
Constant
This variable is constant and should be ignored for analysis
| Constant value | . |
|---|
var31
Numeric
| Distinct count | 29 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.2935366667 |
|---|---|
| Minimum | 0 |
| Maximum | 28 |
| Zeros (%) | 93.4% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 28 |
| Range | 28 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 1.69988113 |
|---|---|
| Coef of variation | 5.791035068 |
| Kurtosis | 86.90305391 |
| Mean | 0.2935366667 |
| MAD | 0.5485065292 |
| Skewness | 8.435097261 |
| Sum | 88061 |
| Variance | 2.889595857 |
| Memory size | 2.3 MiB |
| Value | Count | Frequency (%) | |
| 0 | 280292 | 93.4% | |
| 1 | 9885 | 3.3% | |
| 2 | 946 | 0.3% | |
| 5 | 914 | 0.3% | |
| 10 | 884 | 0.3% | |
| 6 | 877 | 0.3% | |
| 4 | 876 | 0.3% | |
| 7 | 855 | 0.3% | |
| 8 | 855 | 0.3% | |
| 9 | 839 | 0.3% | |
| Other values (19) | 2777 | 0.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 280292 | 93.4% | |
| 1 | 9885 | 3.3% | |
| 2 | 946 | 0.3% | |
| 3 | 822 | 0.3% | |
| 4 | 876 | 0.3% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 28 | 5 | < 0.1% | |
| 27 | 2 | < 0.1% | |
| 26 | 88 | < 0.1% | |
| 25 | 87 | < 0.1% | |
| 24 | 65 | < 0.1% |
var32
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 187880 | 62.6% | |
| 1 | 112120 | 37.4% |
var33
Categorical
| Distinct count | 6 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| other | |
|---|---|
| news_channel1 | 8285 |
| news_channel2 | 6062 |
| Other values (3) | 12681 |
| Value | Count | Frequency (%) | |
| other | 272972 | 91.0% | |
| news_channel1 | 8285 | 2.8% | |
| news_channel2 | 6062 | 2.0% | |
| entertainment_channel1 | 5563 | 1.9% | |
| entertainment_channel2 | 4904 | 1.6% | |
| movie_channel1 | 2214 | 0.7% |
| Max length | 22 |
|---|---|
| Mean length | 6.042136667 |
| Min length | 5 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
var34
Categorical
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Never | |
|---|---|
| Pending | |
| Active | |
| Other values (2) |
| Value | Count | Frequency (%) | |
| Never | 105758 | 35.3% | |
| Pending | 104447 | 34.8% | |
| Active | 48580 | 16.2% | |
| Inactive | 34526 | 11.5% | |
| Cancelled | 6689 | 2.2% |
| Max length | 9 |
|---|---|
| Mean length | 6.292693333 |
| Min length | 5 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
var35
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Standard | |
|---|---|
| CreditCard | 10127 |
| Electronic Transfer | 6723 |
| Value | Count | Frequency (%) | |
| Standard | 283150 | 94.4% | |
| CreditCard | 10127 | 3.4% | |
| Electronic Transfer | 6723 | 2.2% |
| Max length | 19 |
|---|---|
| Mean length | 8.314023333 |
| Min length | 8 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
var36
Categorical
| Distinct count | 14 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Video/Internet | |
|---|---|
| Video/Internet/Voice | |
| Internet Only | |
| Other values (11) |
| Value | Count | Frequency (%) | |
| Video/Internet | 109287 | 36.4% | |
| Video/Internet/Voice | 98173 | 32.7% | |
| Internet Only | 63010 | 21.0% | |
| Video Only | 9195 | 3.1% | |
| Internet/Voice | 8072 | 2.7% | |
| Video/Internet/Voice/Homesecurity | 5603 | 1.9% | |
| Video/Internet/Homesecurity | 5153 | 1.7% | |
| Internet/Homesecurity | 714 | 0.2% | |
| Video/Voice | 359 | 0.1% | |
| Homesecurity Only | 160 | 0.1% | |
| Other values (4) | 274 | 0.1% |
| Max length | 33 |
|---|---|
| Mean length | 16.22913 |
| Min length | 10 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
var37
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| N | |
|---|---|
| Y | 4698 |
| Value | Count | Frequency (%) | |
| N | 295302 | 98.4% | |
| Y | 4698 | 1.6% |
var38
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Other | |
|---|---|
| Agent | |
| Self Service | 13332 |
| Value | Count | Frequency (%) | |
| Other | 221433 | 73.8% | |
| Agent | 65235 | 21.7% | |
| Self Service | 13332 | 4.4% |
| Max length | 12 |
|---|---|
| Mean length | 5.31108 |
| Min length | 5 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
var39
Categorical
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Single Housing | |
|---|---|
| Multi Housing | |
| Exclude mapping | 2209 |
| Other values (2) | 579 |
| Value | Count | Frequency (%) | |
| Single Housing | 214838 | 71.6% | |
| Multi Housing | 82374 | 27.5% | |
| Exclude mapping | 2209 | 0.7% | |
| Other | 310 | 0.1% | |
| Commercial | 269 | 0.1% |
| Max length | 15 |
|---|---|
| Mean length | 13.71989667 |
| Min length | 5 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
var4
Numeric
| Distinct count | 25157 |
|---|---|
| Unique (%) | 8.4% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 4893.003973 |
|---|---|
| Minimum | 0 |
| Maximum | 103192 |
| Zeros (%) | < 0.1% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 75 |
| Q1 | 688 |
| Median | 2161 |
| Q3 | 5302 |
| 95-th percentile | 13584.05 |
| Maximum | 103192 |
| Range | 103192 |
| Interquartile range | 4614 |
Descriptive statistics
| Standard deviation | 10742.37634 |
|---|---|
| Coef of variation | 2.195456289 |
| Kurtosis | 33.86311868 |
| Mean | 4893.003973 |
| MAD | 4846.616666 |
| Skewness | 5.49688504 |
| Sum | 1467901192 |
| Variance | 115398649.5 |
| Memory size | 2.3 MiB |
| Value | Count | Frequency (%) | |
| 31 | 439 | 0.1% | |
| 62 | 432 | 0.1% | |
| 42 | 356 | 0.1% | |
| 32 | 355 | 0.1% | |
| 58 | 351 | 0.1% | |
| 36 | 349 | 0.1% | |
| 53 | 343 | 0.1% | |
| 39 | 339 | 0.1% | |
| 38 | 331 | 0.1% | |
| 44 | 330 | 0.1% | |
| Other values (25147) | 296375 | 98.8% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 84 | < 0.1% | |
| 1 | 96 | < 0.1% | |
| 2 | 80 | < 0.1% | |
| 3 | 95 | < 0.1% | |
| 4 | 85 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 103192 | 1 | < 0.1% | |
| 103132 | 1 | < 0.1% | |
| 103101 | 1 | < 0.1% | |
| 103091 | 1 | < 0.1% | |
| 103076 | 1 | < 0.1% |
var40
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| N | |
|---|---|
| Y |
| Value | Count | Frequency (%) | |
| N | 170475 | 56.8% | |
| Y | 129525 | 43.2% |
var5
Numeric
| Distinct count | 21 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.5130933333 |
|---|---|
| Minimum | 0 |
| Maximum | 20 |
| Zeros (%) | 86.2% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 3 |
| Maximum | 20 |
| Range | 20 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 1.969463927 |
|---|---|
| Coef of variation | 3.838412623 |
| Kurtosis | 36.33028714 |
| Mean | 0.5130933333 |
| MAD | 0.8848841833 |
| Skewness | 5.655220658 |
| Sum | 153928 |
| Variance | 3.878788161 |
| Memory size | 2.3 MiB |
| Value | Count | Frequency (%) | |
| 0 | 258691 | 86.2% | |
| 1 | 16603 | 5.5% | |
| 2 | 5841 | 1.9% | |
| 3 | 5263 | 1.8% | |
| 4 | 5210 | 1.7% | |
| 6 | 801 | 0.3% | |
| 5 | 775 | 0.3% | |
| 12 | 763 | 0.3% | |
| 7 | 708 | 0.2% | |
| 11 | 703 | 0.2% | |
| Other values (11) | 4642 | 1.5% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 258691 | 86.2% | |
| 1 | 16603 | 5.5% | |
| 2 | 5841 | 1.9% | |
| 3 | 5263 | 1.8% | |
| 4 | 5210 | 1.7% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 20 | 110 | < 0.1% | |
| 19 | 107 | < 0.1% | |
| 18 | 126 | < 0.1% | |
| 17 | 401 | 0.1% | |
| 16 | 399 | 0.1% |
var6
Numeric
| Distinct count | 10 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 5.039663333 |
|---|---|
| Minimum | 0 |
| Maximum | 9 |
| Zeros (%) | 10.1% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 2 |
| Median | 5 |
| Q3 | 8 |
| 95-th percentile | 9 |
| Maximum | 9 |
| Range | 9 |
| Interquartile range | 6 |
Descriptive statistics
| Standard deviation | 2.933883464 |
|---|---|
| Coef of variation | 0.5821586225 |
| Kurtosis | -1.18064035 |
| Mean | 5.039663333 |
| MAD | 2.529562411 |
| Skewness | -0.339797258 |
| Sum | 1511899 |
| Variance | 8.607672179 |
| Memory size | 2.3 MiB |
| Value | Count | Frequency (%) | |
| 7 | 46985 | 15.7% | |
| 8 | 42404 | 14.1% | |
| 9 | 34852 | 11.6% | |
| 5 | 33110 | 11.0% | |
| 0 | 30269 | 10.1% | |
| 2 | 25329 | 8.4% | |
| 6 | 24754 | 8.3% | |
| 4 | 22605 | 7.5% | |
| 1 | 22062 | 7.4% | |
| 3 | 17630 | 5.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 30269 | 10.1% | |
| 1 | 22062 | 7.4% | |
| 2 | 25329 | 8.4% | |
| 3 | 17630 | 5.9% | |
| 4 | 22605 | 7.5% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 9 | 34852 | 11.6% | |
| 8 | 42404 | 14.1% | |
| 7 | 46985 | 15.7% | |
| 6 | 24754 | 8.3% | |
| 5 | 33110 | 11.0% |
var7
Numeric
| Distinct count | 105 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 2.24254 |
|---|---|
| Minimum | 0 |
| Maximum | 104 |
| Zeros (%) | 77.0% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 14 |
| Maximum | 104 |
| Range | 104 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 8.078041751 |
|---|---|
| Coef of variation | 3.602184019 |
| Kurtosis | 48.05825317 |
| Mean | 2.24254 |
| MAD | 3.657497077 |
| Skewness | 6.141514161 |
| Sum | 672762 |
| Variance | 65.25475853 |
| Memory size | 2.3 MiB |
| Value | Count | Frequency (%) | |
| 0 | 231090 | 77.0% | |
| 1 | 23617 | 7.9% | |
| 5 | 5239 | 1.7% | |
| 2 | 4333 | 1.4% | |
| 4 | 4173 | 1.4% | |
| 3 | 4136 | 1.4% | |
| 9 | 1437 | 0.5% | |
| 15 | 1419 | 0.5% | |
| 17 | 1411 | 0.5% | |
| 7 | 1407 | 0.5% | |
| Other values (95) | 21738 | 7.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 231090 | 77.0% | |
| 1 | 23617 | 7.9% | |
| 2 | 4333 | 1.4% | |
| 3 | 4136 | 1.4% | |
| 4 | 4173 | 1.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 104 | 20 | < 0.1% | |
| 103 | 17 | < 0.1% | |
| 102 | 22 | < 0.1% | |
| 101 | 20 | < 0.1% | |
| 100 | 31 | < 0.1% |
var8
Numeric
| Distinct count | 853 |
|---|---|
| Unique (%) | 0.3% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 25.50675667 |
|---|---|
| Minimum | 0 |
| Maximum | 1783 |
| Zeros (%) | 37.6% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 3 |
| Q3 | 20 |
| 95-th percentile | 95 |
| Maximum | 1783 |
| Range | 1783 |
| Interquartile range | 20 |
Descriptive statistics
| Standard deviation | 81.53555295 |
|---|---|
| Coef of variation | 3.196625663 |
| Kurtosis | 48.77571722 |
| Mean | 25.50675667 |
| MAD | 34.11656982 |
| Skewness | 6.204837964 |
| Sum | 7652027 |
| Variance | 6648.046395 |
| Memory size | 2.3 MiB |
| Value | Count | Frequency (%) | |
| 0 | 112949 | 37.6% | |
| 5 | 15842 | 5.3% | |
| 2 | 14650 | 4.9% | |
| 1 | 14566 | 4.9% | |
| 3 | 13923 | 4.6% | |
| 4 | 10771 | 3.6% | |
| 8 | 9127 | 3.0% | |
| 7 | 5851 | 2.0% | |
| 6 | 5778 | 1.9% | |
| 27 | 5339 | 1.8% | |
| Other values (843) | 91204 | 30.4% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 112949 | 37.6% | |
| 1 | 14566 | 4.9% | |
| 2 | 14650 | 4.9% | |
| 3 | 13923 | 4.6% | |
| 4 | 10771 | 3.6% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 1783 | 2 | < 0.1% | |
| 1762 | 1 | < 0.1% | |
| 1744 | 1 | < 0.1% | |
| 1722 | 1 | < 0.1% | |
| 1711 | 1 | < 0.1% |
var9
Numeric
| Distinct count | 219914 |
|---|---|
| Unique (%) | 73.3% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 320537.7138 |
|---|---|
| Minimum | 0 |
| Maximum | 1950000 |
| Zeros (%) | < 0.1% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 83006.9 |
| Q1 | 162816 |
| Median | 262081.5 |
| Q3 | 349640.25 |
| 95-th percentile | 861220.2 |
| Maximum | 1950000 |
| Range | 1950000 |
| Interquartile range | 186824.25 |
Descriptive statistics
| Standard deviation | 264835.4714 |
|---|---|
| Coef of variation | 0.8262225006 |
| Kurtosis | 10.86470546 |
| Mean | 320537.7138 |
| MAD | 164809.9089 |
| Skewness | 2.887480538 |
| Sum | 9.616131413e+10 |
| Variance | 7.013782692e+10 |
| Memory size | 2.3 MiB |
| Value | Count | Frequency (%) | |
| 227195 | 8 | < 0.1% | |
| 242021 | 8 | < 0.1% | |
| 255025 | 7 | < 0.1% | |
| 164535 | 7 | < 0.1% | |
| 234687 | 7 | < 0.1% | |
| 231394 | 7 | < 0.1% | |
| 294769 | 7 | < 0.1% | |
| 238484 | 7 | < 0.1% | |
| 292639 | 7 | < 0.1% | |
| 273415 | 6 | < 0.1% | |
| Other values (219904) | 299929 | > 99.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 1 | < 0.1% | |
| 1 | 1 | < 0.1% | |
| 14 | 1 | < 0.1% | |
| 24 | 1 | < 0.1% | |
| 32 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 1950000 | 1 | < 0.1% | |
| 1949942 | 1 | < 0.1% | |
| 1949758 | 1 | < 0.1% | |
| 1949678 | 1 | < 0.1% | |
| 1949670 | 1 | < 0.1% |
First rows
| cust_id | self_service_platform | var1 | var10 | var11 | var12 | var13 | var14 | var15 | var16 | var2 | var21 | var22 | var23 | var24 | var25 | var26 | var27 | var28 | var29 | var3 | var30 | var31 | var32 | var33 | var34 | var35 | var36 | var37 | var38 | var39 | var4 | var40 | var5 | var6 | var7 | var8 | var9 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 100001.0 | Desktop | 2667.0 | 0.0 | 0.0 | 109.0 | 447.0 | 0.0 | 161.0 | 0.0 | 0.0 | 9.0 | 85287.0 | 27.0 | 0.0 | 0.0 | 4.0 | 153.0 | 0.0 | 0.0 | 0.0 | . | 0.0 | 0.0 | other | Inactive | Standard | Video/Internet/Voice | N | Other | Single Housing | 1768.0 | N | 0.0 | 4.0 | 0.0 | 2.0 | 291016.0 |
| 1 | 100002.0 | Desktop | 435.0 | 0.0 | 0.0 | 17.0 | 135.0 | 0.0 | 34.0 | 0.0 | 0.0 | 4.0 | 60868.0 | 4.0 | 0.0 | 0.0 | 1.0 | 74.0 | 0.0 | 0.0 | 0.0 | . | 0.0 | 0.0 | other | Never | Standard | Video/Internet | N | Other | Single Housing | 515.0 | N | 0.0 | 3.0 | 0.0 | 0.0 | 137667.0 |
| 2 | 100003.0 | Desktop | 1520.0 | 0.0 | 0.0 | 120.0 | 453.0 | 0.0 | 112.0 | 0.0 | 0.0 | 10.0 | 92324.0 | 26.0 | 0.0 | 0.0 | 5.0 | 133.0 | 0.0 | 0.0 | 0.0 | . | 0.0 | 0.0 | other | Inactive | Standard | Video/Internet/Voice | N | Agent | Single Housing | 2280.0 | Y | 0.0 | 6.0 | 0.0 | 4.0 | 301567.0 |
| 3 | 100004.0 | Desktop | 4393.0 | 1.0 | 0.0 | 726.0 | 797.0 | 1.0 | 266.0 | 0.0 | 0.0 | 33.0 | 117785.0 | 71.0 | 20.0 | 0.0 | 11.0 | 208.0 | 8.0 | 10.0 | 1.0 | . | 0.0 | 1.0 | other | Active | Standard | Internet Only | N | Other | Single Housing | 5731.0 | N | 0.0 | 8.0 | 1.0 | 27.0 | 436735.0 |
| 4 | 100005.0 | STB | 3587.0 | 0.0 | 0.0 | 237.0 | 614.0 | 0.0 | 166.0 | 0.0 | 0.0 | 15.0 | 100083.0 | 46.0 | 33.0 | 0.0 | 6.0 | 155.0 | 0.0 | 1.0 | 0.0 | . | 0.0 | 0.0 | movie_channel1 | Never | Standard | Internet Only | N | Other | Multi Housing | 2493.0 | N | 0.0 | 7.0 | 0.0 | 7.0 | 314970.0 |
| 5 | 100006.0 | Mobile App | 1071.0 | 1.0 | 0.0 | 655.0 | 694.0 | 1.0 | 159.0 | 0.0 | 0.0 | 45.0 | 89112.0 | 78.0 | 7.0 | 0.0 | 18.0 | 186.0 | 11.0 | 10.0 | 1.0 | . | 0.0 | 1.0 | other | Active | Standard | Internet/Voice | Y | Other | Single Housing | 6840.0 | Y | 0.0 | 8.0 | 0.0 | 33.0 | 345363.0 |
| 6 | 100007.0 | Desktop | 3079.0 | 0.0 | 0.0 | 268.0 | 614.0 | 0.0 | 191.0 | 0.0 | 0.0 | 19.0 | 103460.0 | 47.0 | 30.0 | 0.0 | 6.0 | 169.0 | 0.0 | 2.0 | 0.0 | . | 0.0 | 0.0 | other | Never | Standard | Video/Internet/Voice | N | Agent | Exclude mapping | 3105.0 | N | 0.0 | 7.0 | 0.0 | 7.0 | 331691.0 |
| 7 | 100008.0 | STB | 1529.0 | 11.0 | 0.0 | 772.0 | 646.0 | 1.0 | 313.0 | 0.0 | 0.0 | 29.0 | 71513.0 | 69.0 | 3.0 | 0.0 | 8.0 | 209.0 | 9.0 | 11.0 | 1.0 | . | 0.0 | 1.0 | other | Pending | Standard | Video/Internet | N | Self Service | Single Housing | 7506.0 | Y | 1.0 | 3.0 | 0.0 | 53.0 | 244942.0 |
| 8 | 100009.0 | Mobile App | 95.0 | 0.0 | 0.0 | 0.0 | 25.0 | 0.0 | 2.0 | 0.0 | 0.0 | 0.0 | 26467.0 | 0.0 | 0.0 | 0.0 | 1.0 | 33.0 | 0.0 | 0.0 | 0.0 | . | 0.0 | 0.0 | entertainment_channel1 | Pending | Standard | Video/Internet | N | Other | Single Housing | 84.0 | N | 0.0 | 0.0 | 0.0 | 0.0 | 60845.0 |
| 9 | 100010.0 | Desktop | 7784.0 | 1.0 | 0.0 | 965.0 | 983.0 | 1.0 | 353.0 | 0.0 | 0.0 | 35.0 | 134331.0 | 75.0 | 21.0 | 0.0 | 14.0 | 215.0 | 10.0 | 10.0 | 1.0 | . | 0.0 | 1.0 | other | Pending | Standard | Video/Internet | N | Other | Single Housing | 5899.0 | N | 1.0 | 9.0 | 2.0 | 30.0 | 507727.0 |
Last rows
| cust_id | self_service_platform | var1 | var10 | var11 | var12 | var13 | var14 | var15 | var16 | var2 | var21 | var22 | var23 | var24 | var25 | var26 | var27 | var28 | var29 | var3 | var30 | var31 | var32 | var33 | var34 | var35 | var36 | var37 | var38 | var39 | var4 | var40 | var5 | var6 | var7 | var8 | var9 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 299990 | 399991.0 | Desktop | 12112.0 | 2.0 | 1.0 | 1989.0 | 1414.0 | 1.0 | 464.0 | 1.0 | 0.0 | 61.0 | 201678.0 | 96.0 | 29.0 | 1.0 | 15.0 | 232.0 | 16.0 | 12.0 | 1.0 | . | 1.0 | 1.0 | news_channel2 | Never | Standard | Video/Internet | N | Other | Single Housing | 11063.0 | Y | 4.0 | 9.0 | 19.0 | 62.0 | 616938.0 |
| 299991 | 399992.0 | Desktop | 1808.0 | 0.0 | 0.0 | 209.0 | 511.0 | 0.0 | 109.0 | 0.0 | 0.0 | 12.0 | 88084.0 | 33.0 | 1.0 | 0.0 | 5.0 | 124.0 | 0.0 | 0.0 | 0.0 | . | 0.0 | 0.0 | other | Inactive | Standard | Internet Only | N | Agent | Single Housing | 2001.0 | Y | 0.0 | 7.0 | 0.0 | 0.0 | 244607.0 |
| 299992 | 399993.0 | Desktop | 9753.0 | 2.0 | 1.0 | 1627.0 | 1047.0 | 1.0 | 532.0 | 1.0 | 0.0 | 64.0 | 152939.0 | 89.0 | 41.0 | 1.0 | 31.0 | 229.0 | 26.0 | 11.0 | 1.0 | . | 0.0 | 1.0 | other | Cancelled | Standard | Internet Only | N | Other | Single Housing | 9228.0 | Y | 1.0 | 9.0 | 5.0 | 42.0 | 659842.0 |
| 299993 | 399994.0 | Desktop | 4273.0 | 0.0 | 0.0 | 396.0 | 646.0 | 0.0 | 209.0 | 0.0 | 0.0 | 21.0 | 107295.0 | 54.0 | 148.0 | 0.0 | 7.0 | 177.0 | 4.0 | 3.0 | 0.0 | . | 0.0 | 0.0 | other | Active | Standard | Video/Internet/Voice | N | Other | Multi Housing | 3192.0 | N | 0.0 | 7.0 | 0.0 | 10.0 | 340542.0 |
| 299994 | 399995.0 | Desktop | 3656.0 | 0.0 | 0.0 | 249.0 | 574.0 | 0.0 | 179.0 | 0.0 | 0.0 | 17.0 | 98632.0 | 44.0 | 35.0 | 0.0 | 7.0 | 166.0 | 1.0 | 0.0 | 0.0 | . | 0.0 | 0.0 | other | Active | Standard | Video/Internet | N | Other | Single Housing | 2705.0 | N | 0.0 | 7.0 | 0.0 | 6.0 | 327173.0 |
| 299995 | 399996.0 | Desktop | 53.0 | 0.0 | 0.0 | 0.0 | 68.0 | 0.0 | 3.0 | 0.0 | 0.0 | 0.0 | 28748.0 | 0.0 | 0.0 | 0.0 | 1.0 | 12.0 | 0.0 | 0.0 | 0.0 | . | 0.0 | 0.0 | other | Active | Standard | Internet Only | N | Other | Multi Housing | 74.0 | Y | 0.0 | 0.0 | 0.0 | 0.0 | 59734.0 |
| 299996 | 399997.0 | Mobile Web | 4083.0 | 1.0 | 0.0 | 332.0 | 691.0 | 1.0 | 212.0 | 0.0 | 0.0 | 20.0 | 108589.0 | 57.0 | 148.0 | 0.0 | 7.0 | 177.0 | 6.0 | 5.0 | 0.0 | . | 0.0 | 0.0 | other | Pending | Standard | Internet Only | N | Other | Single Housing | 3244.0 | N | 0.0 | 8.0 | 0.0 | 10.0 | 349569.0 |
| 299997 | 399998.0 | Desktop | 2730.0 | 0.0 | 0.0 | 88.0 | 444.0 | 0.0 | 103.0 | 0.0 | 0.0 | 14.0 | 88551.0 | 42.0 | 1.0 | 0.0 | 6.0 | 149.0 | 0.0 | 0.0 | 0.0 | . | 0.0 | 0.0 | other | Pending | Standard | Internet Only | N | Agent | Multi Housing | 2432.0 | N | 0.0 | 4.0 | 0.0 | 5.0 | 264067.0 |
| 299998 | 399999.0 | Desktop | 2875.0 | 0.0 | 0.0 | 81.0 | 481.0 | 0.0 | 117.0 | 0.0 | 0.0 | 11.0 | 96020.0 | 32.0 | 1.0 | 0.0 | 5.0 | 116.0 | 0.0 | 0.0 | 0.0 | . | 0.0 | 0.0 | other | Pending | Standard | Video/Internet | N | Other | Single Housing | 2321.0 | Y | 0.0 | 4.0 | 0.0 | 1.0 | 295776.0 |
| 299999 | 400000.0 | Desktop | 1533.0 | 0.0 | 0.0 | 166.0 | 315.0 | 0.0 | 146.0 | 0.0 | 0.0 | 8.0 | 92161.0 | 29.0 | 0.0 | 0.0 | 3.0 | 119.0 | 0.0 | 0.0 | 0.0 | . | 0.0 | 0.0 | news_channel1 | Never | Standard | Video/Internet/Voice | Y | Self Service | Single Housing | 1249.0 | Y | 0.0 | 5.0 | 0.0 | 3.0 | 257782.0 |